﻿using KPIS.GERP.Models.BGM;
using KPIS.GERP.Models.SYS;
using System;
using System.Data.Entity.Migrations;

namespace KPIS.GERP.Models.Migrations
{
    public partial class Configuration
    {
        public void SeedBGM(GERPContext context)
        {
            context.MasBudgetExpenseGroups.AddOrUpdate(
                new BGM.MasBudgetExpenseGroup
                    {
                        BgExpGrpId = 1,
                        Code = "1",
                        GfmisCode = "1",
                        Name = "งบบุคลากร",
                        Descr = null,
                        RecordStatus = SYS.RecordStatus.UsedStatus,
                        CreatedBy = 1,
                        CreatedWhen = DateTime.Now
                    }
                );
            context.MasBudgetExpenseGroups.AddOrUpdate(
                new BGM.MasBudgetExpenseGroup
                    {
                        BgExpGrpId = 2,
                        Code = "2",
                        GfmisCode = "2",
                        Name = "งบดำเนินงาน",
                        Descr = null,
                        RecordStatus = SYS.RecordStatus.UsedStatus,
                        CreatedBy = 1,
                        CreatedWhen = DateTime.Now
                    }
                );
            context.MasBudgetExpenseGroups.AddOrUpdate(
                new BGM.MasBudgetExpenseGroup
                    {
                        BgExpGrpId = 3,
                        Code = "3",
                        GfmisCode = "3",
                        Name = "งบลงทุน",
                        Descr = null,
                        RecordStatus = SYS.RecordStatus.UsedStatus,
                        CreatedBy = 1,
                        CreatedWhen = DateTime.Now
                    }
                );
            context.MasBudgetExpenseGroups.AddOrUpdate(
                new BGM.MasBudgetExpenseGroup
                    {
                        BgExpGrpId = 4,
                        Code = "4",
                        GfmisCode = "4",
                        Name = "งบอุดหนุน",
                        Descr = null,
                        RecordStatus = SYS.RecordStatus.UsedStatus,
                        CreatedBy = 1,
                        CreatedWhen = DateTime.Now
                    }
                );
            context.MasBudgetExpenseGroups.AddOrUpdate(
                new BGM.MasBudgetExpenseGroup
                    {
                        BgExpGrpId = 5,
                        Code = "5",
                        GfmisCode = "5",
                        Name = "งบรายจ่ายอื่น",
                        Descr = null,
                        RecordStatus = SYS.RecordStatus.UsedStatus,
                        CreatedBy = 1,
                        CreatedWhen = DateTime.Now
                    }
                );


            context.MasBudgetSourceTypes.AddOrUpdate(new BGM.MasBudgetSourceType {BgSourceTypeId = 1, Code = "1", Name = "เงินงบประมาณแผ่นดิน", RecordStatus = SYS.RecordStatus.UsedStatus, CreatedBy = 1, CreatedWhen = DateTime.Now});
            context.MasBudgetSourceTypes.AddOrUpdate(new BGM.MasBudgetSourceType {BgSourceTypeId = 2, Code = "2", Name = "เงินนอกงบประมาณแผ่นดิน", RecordStatus = SYS.RecordStatus.UsedStatus, CreatedBy = 1, CreatedWhen = DateTime.Now});
            context.MasBudgetSourceTypes.AddOrUpdate(new BGM.MasBudgetSourceType {BgSourceTypeId = 3, Code = "3", Name = "งบประมาณเบิกแทนกัน", RecordStatus = SYS.RecordStatus.DeletedStatus, CreatedBy = 1, CreatedWhen = DateTime.Now});
            context.MasBudgetSourceTypes.AddOrUpdate(new BGM.MasBudgetSourceType {BgSourceTypeId = 4, Code = "4", Name = "เงินงบกลาง", RecordStatus = SYS.RecordStatus.DeletedStatus, CreatedBy = 1, CreatedWhen = DateTime.Now});
            //context.MasBudgetSourceTypes.AddOrUpdate(new BGM.MasBudgetSourceType { BgSourceTypeId = 5, Code = "5", Name = "ทดสอบ", RecordStatus = SYS.RecordStatus.DeletedStatus, CreatedBy = 1, CreatedWhen = DateTime.Now });
            //context.MasBudgetSourceTypes.AddOrUpdate(new BGM.MasBudgetSourceType { BgSourceTypeId = 6, Code = "6", Name = "ทดสอบ", RecordStatus = SYS.RecordStatus.DeletedStatus, CreatedBy = 1, CreatedWhen = DateTime.Now });
            //context.MasBudgetSourceTypes.AddOrUpdate(new BGM.MasBudgetSourceType { BgSourceTypeId = 7, Code = "7", Name = "dd", RecordStatus = SYS.RecordStatus.DeletedStatus, CreatedBy = 1, CreatedWhen = DateTime.Now });
            //context.MasBudgetSourceTypes.AddOrUpdate(new BGM.MasBudgetSourceType { BgSourceTypeId = 8, Code = "8", Name = "ทดสอบ", RecordStatus = SYS.RecordStatus.DeletedStatus, CreatedBy = 1, CreatedWhen = DateTime.Now });

            context.MasBudgetSources.AddOrUpdate(new MasBudgetSource {BgSourceId = 1, Code = "10000", Name = "เงินงบประมาณ", Description = "", UpperBgSourceId = null, BgSourceTypeId = 1, YearTypeId = 1, UsePetition = true, UseRequest = true, RecordStatus = "U", GfmisCode = ""});
            //context.MasBudgetSources.AddOrUpdate(new MasBudgetSource {BgSourceId = 2, Code = "20000", Name = "กองทุน", Description = "", UpperBgSourceId = null, BgSourceTypeId = 2, YearTypeId = 1, UsePetition = false, UseRequest = true, RecordStatus = "D", GfmisCode = ""});
            //context.MasBudgetSources.AddOrUpdate(new MasBudgetSource {BgSourceId = 3, Code = "30000", Name = "งบประมาณเบิกแทนกัน", Description = "null", UpperBgSourceId = null, BgSourceTypeId = 3, YearTypeId = 1, UsePetition = false, UseRequest = true, RecordStatus = "D", GfmisCode = ""});
            //context.MasBudgetSources.AddOrUpdate(new MasBudgetSource {BgSourceId = 4, Code = "40000", Name = "เงินอุดหนุนจากหน่วยงานอื่น", Description = "null", UpperBgSourceId = null, BgSourceTypeId = null, YearTypeId = 1, UsePetition = true, UseRequest = true, RecordStatus = "D", GfmisCode = ""});
            //context.MasBudgetSources.AddOrUpdate(new MasBudgetSource {BgSourceId = 6, Code = "210001", Name = "เงินกองทุนส่งเสริมการค้าระหว่างประเทศ", Description = "", UpperBgSourceId = 2, BgSourceTypeId = 2, YearTypeId = 1, UsePetition = false, UseRequest = true, RecordStatus = "D", GfmisCode = ""});
            //context.MasBudgetSources.AddOrUpdate(new MasBudgetSource {BgSourceId = 7, Code = "210003", Name = "เงินกิจกรรม", Description = "", UpperBgSourceId = 2, BgSourceTypeId = 2, YearTypeId = 1, UsePetition = false, UseRequest = true, RecordStatus = "D", GfmisCode = ""});
            //context.MasBudgetSources.AddOrUpdate(new MasBudgetSource {BgSourceId = 8, Code = "50000", Name = "เงินงบกลาง", Description = "null", UpperBgSourceId = null, BgSourceTypeId = 4, YearTypeId = 1, UsePetition = false, UseRequest = true, RecordStatus = "D", GfmisCode = ""});
            //context.MasBudgetSources.AddOrUpdate(new MasBudgetSource {BgSourceId = 9, Code = "231", Name = "eddd", Description = "fewe", UpperBgSourceId = 1, BgSourceTypeId = 1, YearTypeId = null, UsePetition = false, UseRequest = true, RecordStatus = "D", GfmisCode = "2131"});
            //context.MasBudgetSources.AddOrUpdate(new MasBudgetSource {BgSourceId = 10, Code = "2222", Name = "21321321", Description = "", UpperBgSourceId = null, BgSourceTypeId = 1, YearTypeId = null, UsePetition = false, UseRequest = true, RecordStatus = "D", GfmisCode = "2321"});
            //context.MasBudgetSources.AddOrUpdate(new MasBudgetSource {BgSourceId = 11, Code = "2", Name = "เงินรายได้สรพ.", Description = "", UpperBgSourceId = null, BgSourceTypeId = 2, YearTypeId = null, UsePetition = false, UseRequest = true, RecordStatus = "U", GfmisCode = ""});
            //context.MasBudgetSources.AddOrUpdate(new MasBudgetSource {BgSourceId = 12, Code = "3", Name = "งบกองทุน", Description = "", UpperBgSourceId = null, BgSourceTypeId = 2, YearTypeId = null, UsePetition = false, UseRequest = true, RecordStatus = "D", GfmisCode = ""});
            //context.MasBudgetSources.AddOrUpdate(new MasBudgetSource {BgSourceId = 13, Code = "1111", Name = "เงินรายได้", Description = "", UpperBgSourceId = 1, BgSourceTypeId = 1, YearTypeId = null, UsePetition = false, UseRequest = true, RecordStatus = "D", GfmisCode = ""});
            //context.MasBudgetSources.AddOrUpdate(new MasBudgetSource {BgSourceId = 14, Code = "1", Name = "1.11111E+30", Description = "1", UpperBgSourceId = null, BgSourceTypeId = 1, YearTypeId = null, UsePetition = false, UseRequest = true, RecordStatus = "D", GfmisCode = "1"});
            //context.MasBudgetSources.AddOrUpdate(new MasBudgetSource {BgSourceId = 15, Code = "1234", Name = "กทม.", Description = "", UpperBgSourceId = null, BgSourceTypeId = 2, YearTypeId = null, UsePetition = false, UseRequest = true, RecordStatus = "U", GfmisCode = ""});

            context.ProjectScopeses.AddOrUpdate(new MasScopes
                {
                    BgmScopeId = 1,
                    BgmScopeName = "ProjectScopes (MasScope) #1",
                    RecordStatus = RecordStatus.UsedStatus
                });
            context.ProjectScopeses.AddOrUpdate(new MasScopes
                {
                    BgmScopeId = 1,
                    BgmScopeName = "ProjectScopes (MasScope) #1",
                    RecordStatus = RecordStatus.UsedStatus
                });
            context.ProjectTypes.AddOrUpdate(new ProjectType
                {
                    PrjTypeId = 1,
                    PrjTypeName = "Project Type #1",
                    RecordStatus = RecordStatus.UsedStatus
                });
            context.StrategyDataLists.AddOrUpdate(new StrategyDataList
                {
                    BgmStratListId = 1,
                    BgmStratListName = "StrategyDataList#1",
                    RecordStatus = RecordStatus.UsedStatus
                });
            context.ProjectManagers.AddOrUpdate(new ProjectManager
                {
                    EmpId = 50,
                    ProjId = 1,
                    ProjMngId = 1
                });
            context.ProjectManagers.AddOrUpdate(new ProjectManager
                {
                    EmpId = 51,
                    ProjId = 2,
                    ProjMngId = 2
                });
            context.ProjectManagers.AddOrUpdate(new ProjectManager
                {
                    EmpId = 52,
                    ProjId = 3,
                    ProjMngId = 3
                });
            {
                context.Projects.AddOrUpdate(new Project
                    {
                        ProjId = 1,
                        Code = "1",
                        Name = "Project #1",
                        Description = "",
                        ProjMngId = 1,
                        ProjectScope = 1,
                        ProjectDate = DateTime.Now,
                        ProjectReasons = "",
                        ProjectObject = "",
                        ProjectTarget = "",
                        ProjectPlan = "",
                        ProjectRemarks = "",
                        StratListId = 1,
                        ProjectTypeId = 1,
                        JobSiteId = 1,
                        JobSiteIdMain = 1,
                        BgYear = 1,
                        DateStart = DateTime.Now,
                        DateEnd = DateTime.Now.AddDays(112),
                        GfmisCode = "",
                        AltProjId = null,
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.Projects.AddOrUpdate(new Project
                    {
                        ProjId = 2,
                        Code = "2",
                        Name = "Project #2",
                        Description = "",
                        ProjMngId = 2,
                        ProjectScope = 1,
                        ProjectDate = DateTime.Now,
                        ProjectReasons = "",
                        ProjectObject = "",
                        ProjectTarget = "",
                        ProjectPlan = "",
                        ProjectRemarks = "",
                        StratListId = 1,
                        ProjectTypeId = 1,
                        JobSiteId = 1,
                        JobSiteIdMain = 1,
                        BgYear = 1,
                        DateStart = DateTime.Now,
                        DateEnd = DateTime.Now.AddDays(112),
                        GfmisCode = "",
                        AltProjId = null,
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.Projects.AddOrUpdate(new Project
                    {
                        ProjId = 3,
                        Code = "3",
                        Name = "Project #3",
                        Description = "",
                        ProjMngId = 3,
                        ProjectScope = 1,
                        ProjectDate = DateTime.Now,
                        ProjectReasons = "",
                        ProjectObject = "",
                        ProjectTarget = "",
                        ProjectPlan = "",
                        ProjectRemarks = "",
                        StratListId = 1,
                        ProjectTypeId = 1,
                        JobSiteId = 1,
                        JobSiteIdMain = 1,
                        BgYear = 1,
                        DateStart = DateTime.Now,
                        DateEnd = DateTime.Now.AddDays(112),
                        GfmisCode = "",
                        AltProjId = null,
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.ProjectOperations.AddOrUpdate(new ProjectOperation
                    {
                        ProjOperId = 1,
                        Code = "1",
                        Name = "Project Operation #1",
                        Descr = "Project Operation #1",
                        ProjOperDate = DateTime.Now.AddDays(100),
                        StartDate = DateTime.Now.AddDays(101),
                        EndDate = DateTime.Now.AddDays(111),
                        AttendCount = 11,
                        ProjId = 1,
                        EmpId = 5,
                        JobSiteId = 60,
                        IsUse = "Yes",
                        WorkPlace = "",
                        BgYear = 2557,
                        Scope = "",
                        RecordStatus = RecordStatus.UsedStatus
                    });

                context.ProjectOperations.AddOrUpdate(new ProjectOperation
                    {
                        ProjOperId = 2,
                        Code = "1",
                        Name = "Project Operation #2",
                        Descr = "Project Operation #2",
                        ProjOperDate = DateTime.Now.AddDays(200),
                        StartDate = DateTime.Now.AddDays(201),
                        EndDate = DateTime.Now.AddDays(211),
                        AttendCount = 11,
                        ProjId = 2,
                        EmpId = 6,
                        JobSiteId = 60,
                        IsUse = "Yes",
                        WorkPlace = "",
                        BgYear = 2548,
                        Scope = "",
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.ProjectOperations.AddOrUpdate(new ProjectOperation
                    {
                        ProjOperId = 3,
                        Code = "1",
                        Name = "Project Operation #3",
                        Descr = "Project Operation #3",
                        ProjOperDate = DateTime.Now.AddDays(200),
                        StartDate = DateTime.Now.AddDays(201),
                        EndDate = DateTime.Now.AddDays(211),
                        AttendCount = 11,
                        ProjId = 2,
                        EmpId = 6,
                        JobSiteId = 60,
                        IsUse = "Yes",
                        WorkPlace = "",
                        BgYear = 2549,
                        Scope = "",
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.ProjectOperations.AddOrUpdate(new ProjectOperation
                    {
                        ProjOperId = 4,
                        Code = "1",
                        Name = "Project Operation #4",
                        Descr = "Project Operation #4",
                        ProjOperDate = DateTime.Now.AddDays(200),
                        StartDate = DateTime.Now.AddDays(201),
                        EndDate = DateTime.Now.AddDays(211),
                        AttendCount = 11,
                        ProjId = 2,
                        EmpId = 6,
                        JobSiteId = 60,
                        IsUse = "Yes",
                        WorkPlace = "",
                        BgYear = 2550,
                        Scope = "",
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.ProjectOperations.AddOrUpdate(new ProjectOperation
                    {
                        ProjOperId = 5,
                        Code = "1",
                        Name = "Project Operation #5",
                        Descr = "Project Operation #5",
                        ProjOperDate = DateTime.Now.AddDays(200),
                        StartDate = DateTime.Now.AddDays(201),
                        EndDate = DateTime.Now.AddDays(211),
                        AttendCount = 11,
                        ProjId = 2,
                        EmpId = 6,
                        JobSiteId = 60,
                        IsUse = "Yes",
                        WorkPlace = "",
                        BgYear = 2551,
                        Scope = "",
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.ProjectOperations.AddOrUpdate(new ProjectOperation
                    {
                        ProjOperId = 6,
                        Code = "1",
                        Name = "Project Operation #6",
                        Descr = "Project Operation #6",
                        ProjOperDate = DateTime.Now.AddDays(200),
                        StartDate = DateTime.Now.AddDays(201),
                        EndDate = DateTime.Now.AddDays(211),
                        AttendCount = 11,
                        ProjId = 2,
                        EmpId = 6,
                        JobSiteId = 60,
                        IsUse = "Yes",
                        WorkPlace = "",
                        BgYear = 2552,
                        Scope = "",
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.ProjectOperations.AddOrUpdate(new ProjectOperation
                    {
                        ProjOperId = 7,
                        Code = "1",
                        Name = "Project Operation #7",
                        Descr = "Project Operation #7",
                        ProjOperDate = DateTime.Now.AddDays(200),
                        StartDate = DateTime.Now.AddDays(201),
                        EndDate = DateTime.Now.AddDays(211),
                        AttendCount = 11,
                        ProjId = 2,
                        EmpId = 6,
                        JobSiteId = 60,
                        IsUse = "Yes",
                        WorkPlace = "",
                        BgYear = 2553,
                        Scope = "",
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.ProjectOperations.AddOrUpdate(new ProjectOperation
                    {
                        ProjOperId = 8,
                        Code = "1",
                        Name = "Project Operation #8",
                        Descr = "Project Operation #8",
                        ProjOperDate = DateTime.Now.AddDays(200),
                        StartDate = DateTime.Now.AddDays(201),
                        EndDate = DateTime.Now.AddDays(211),
                        AttendCount = 11,
                        ProjId = 2,
                        EmpId = 6,
                        JobSiteId = 60,
                        IsUse = "Yes",
                        WorkPlace = "",
                        BgYear = 2554,
                        Scope = "",
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.ProjectOperations.AddOrUpdate(new ProjectOperation
                    {
                        ProjOperId = 9,
                        Code = "1",
                        Name = "Project Operation #9",
                        Descr = "Project Operation #9",
                        ProjOperDate = DateTime.Now.AddDays(200),
                        StartDate = DateTime.Now.AddDays(201),
                        EndDate = DateTime.Now.AddDays(211),
                        AttendCount = 11,
                        ProjId = 2,
                        EmpId = 6,
                        JobSiteId = 60,
                        IsUse = "Yes",
                        WorkPlace = "",
                        BgYear = 2555,
                        Scope = "",
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.ProjectOperations.AddOrUpdate(new ProjectOperation
                    {
                        ProjOperId = 10,
                        Code = "1",
                        Name = "Project Operation #10",
                        Descr = "Project Operation #10",
                        ProjOperDate = DateTime.Now.AddDays(200),
                        StartDate = DateTime.Now.AddDays(201),
                        EndDate = DateTime.Now.AddDays(211),
                        AttendCount = 11,
                        ProjId = 2,
                        EmpId = 6,
                        JobSiteId = 73,
                        IsUse = "Yes",
                        WorkPlace = "",
                        BgYear = 2556,
                        Scope = "",
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.ProjectOperationExpenses.AddOrUpdate(new ProjectOperationExpense
                    {
                        ProjOperExpId = 1,
                        ProjOperId = 1,
                        Descr = "",
                        ProjExpId = 1,
                        Amount = 10,
                        UnitPrice = 10,
                        UnitQty = 10,
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.ProjectOperationExpenses.AddOrUpdate(new ProjectOperationExpense
                    {
                        ProjOperExpId = 2,
                        ProjOperId = 2,
                        Descr = "",
                        ProjExpId = 1,
                        Amount = 10,
                        UnitPrice = 10,
                        UnitQty = 10,
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.ProjectOperationExpenses.AddOrUpdate(new ProjectOperationExpense
                    {
                        ProjOperExpId = 3,
                        ProjOperId = 3,
                        Descr = "",
                        ProjExpId = 1,
                        Amount = 10,
                        UnitPrice = 10,
                        UnitQty = 10,
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.ProjectOperationExpenses.AddOrUpdate(new ProjectOperationExpense
                    {
                        ProjOperExpId = 4,
                        ProjOperId = 4,
                        Descr = "",
                        ProjExpId = 1,
                        Amount = 10,
                        UnitPrice = 10,
                        UnitQty = 10,
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.ProjectOperationExpenses.AddOrUpdate(new ProjectOperationExpense
                    {
                        ProjOperExpId = 5,
                        ProjOperId = 5,
                        Descr = "",
                        ProjExpId = 1,
                        Amount = 10,
                        UnitPrice = 10,
                        UnitQty = 10,
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.ProjectOperationExpenses.AddOrUpdate(new ProjectOperationExpense
                    {
                        ProjOperExpId = 6,
                        ProjOperId = 6,
                        Descr = "",
                        ProjExpId = 1,
                        Amount = 10,
                        UnitPrice = 10,
                        UnitQty = 10,
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.ProjectOperationExpenses.AddOrUpdate(new ProjectOperationExpense
                    {
                        ProjOperExpId = 7,
                        ProjOperId = 7,
                        Descr = "",
                        ProjExpId = 1,
                        Amount = 10,
                        UnitPrice = 10,
                        UnitQty = 10,
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.ProjectOperationExpenses.AddOrUpdate(new ProjectOperationExpense
                    {
                        ProjOperExpId = 8,
                        ProjOperId = 8,
                        Descr = "",
                        ProjExpId = 1,
                        Amount = 10,
                        UnitPrice = 10,
                        UnitQty = 10,
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.ProjectOperationExpenses.AddOrUpdate(new ProjectOperationExpense
                    {
                        ProjOperExpId = 9,
                        ProjOperId = 9,
                        Descr = "",
                        ProjExpId = 1,
                        Amount = 10,
                        UnitPrice = 10,
                        UnitQty = 10,
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.ProjectOperationExpenses.AddOrUpdate(new ProjectOperationExpense
                    {
                        ProjOperExpId = 10,
                        ProjOperId = 10,
                        Descr = "",
                        ProjExpId = 1,
                        Amount = 10,
                        UnitPrice = 10,
                        UnitQty = 10,
                        RecordStatus = RecordStatus.UsedStatus
                    });
                context.ProjectExpenses.AddOrUpdate(new ProjectExpense
                    {
                        ProjExpId = 1,
                        BgExpId = 1,
                        BgSourceId = 1,

                    });
                context.MasBudgetExpenses.AddOrUpdate(new MasBudgetExpense
                    {
                        BgExpId = 1,
                        Name = "BudgetExpense#1",
                        RecordStatus = RecordStatus.UsedStatus,
                        AccountId = 1,
                        BgExpGrpId = 1
                    });

                context.SystemControls.AddOrUpdate(new SystemControl
                    {
                        Id = 1,
                        BgmSysControlName = "BgYear",
                        BgmSysControlValues = "2556"
                    });
                context.SystemControls.AddOrUpdate(new SystemControl
                {
                    Id = 2,
                        BgmSysControlName = "JobSiteStrategy",
                        BgmSysControlValues = "60"
                    });
                context.SystemControls.AddOrUpdate(new SystemControl
                {
                    Id = 3,
                        BgmSysControlName = "ReqBgYear",
                        BgmSysControlValues = "2556"
                    });
                context.SystemControls.AddOrUpdate(new SystemControl
                {
                    Id =4,
                        BgmSysControlName = "JobSiteOption1",
                        BgmSysControlValues = "60"
                    });
                context.SystemControls.AddOrUpdate(new SystemControl
                {
                    Id = 5,
                        BgmSysControlName = "JobSiteOption2",
                        BgmSysControlValues = "60"
                    });
                context.SystemControls.AddOrUpdate(new SystemControl
                {
                    Id = 6,
                        BgmSysControlName = "JobSiteOption3",
                        BgmSysControlValues = "60"
                    });
            }
        }
    }
}